1. Recover control files from automatic backup using Rman (without Fra)
ORACLE will default to create server parameter files and control files in the $oracle_home/dbs or $ORACLE _home/database directory.
Assuming that the instance parameter file has been restored and the instance is started, the general process of restoring the control file is to set up Oracle_
Restore non-critical Oracle files, redo, temporary files, index files, and password files
The Application of Incremental backup is in the rediscovery stage and is no longer in the restore stage.
Learn about the database settings t
.Restore and restore the missing data files.
5. Open the database.
1. Full recovery of non-critical data files lost in archive Mode
Method 1:
Shutdown abort;
Startup mount;
Alter database create datafile '/home/oracle/test. dbf' as '/home/oracle/test. dbf ';
Recover datafile;
Method 2:
Create tablespace test datafile '
:/oracle1/ora81/database> exit
Back up control files with to trace
SQL> alter Database Backup controlfile to trace;
Database altered.
SQL> shutdown immediate
ORA-01109: Database not open
Database dismounted.
Oracle instance shut down.
SQL>
Find the control file and edit it.
Startup nomount
Create controlfile reuse Database "backup" noresetlogs archivelog
Maxlogfiles 32
Maxlogmembers 2
Maxdatafiles 254
Maxinstances 1
# Maxloghistory 453
Logfile
Gro
ORACLE does not have parameter files and control files. How can I restore databases through rman?Scenario: a dev tells me that a user's table cannot be seen in the production environment and needs to be restored. At this time, the disk directory file of the parameter file control file that is automatically backed up in the production database is broken, therefore
1, in the computer installation "Easyrecovery" and then we open the Easyrecovery software, then in the open interface we choose Media Type: storage devices.
Figure 1: Selecting a Media type
2, find our U disk, such as our U disk is: E disk.
Figure 2: Select the volume label you want to scan
3, select the recovery scenario: Recover deleted files.
4, check your options.
5, save the file.
Note: U disk data has been mistakenly
Recover data: Restore deleted files in LinuxRecover data: Restore deleted files in LinuxGuideHave you ever encountered such a thing? When you find out, you have deleted the key or usedThe "rm" command mistakenly deletes an object that should not be deleted.
In the first case, you can go to the garbage bin, search for t
In CentOS, if a file is accidentally deleted, perform the following steps to restore the file. 1. disable all services. when files are deleted by mistake, in order to restore data as much as possible, you must first disable all ongoing services and avoid data writing, otherwise, the probability of recovery is lower. We can directly # killall process name or # kil
Restore accidentally deleted files in CentOS
In CentOS, if a file is accidentally deleted, perform the following steps to restore the file.
1. Disable all services
When a file is accidentally deleted, in order to restore data as much as possible, you must first disable all ongoing services and do not write data. Other
How to restore files backed up with "Easy backup" in the Win10 system, win10 easy backup
In the article "how to back up files in Windows 10 System", I explained the file backup method, But how should I restore the files backed up with the "Easy backup" software? This articl
file system to be detached, as shown below:
# Lsof/gtes11/
Command PID user FD type device size node name
Bash 4208 root CWD dir 3, 1 4096 2/gtes11/
Vim 4230 root CWD dir 3, 1 4096 2/gtes11/
In this example, the user root is performing some operations in its/gtes11 directory. A Bash instance is running, and its current directory is/gtes11, And the other shows the files that Vim is editing under/gtes11. To successfully uninstall/gtes11, you shou
Using grep to restore accidentally deleted text files as long-term computer users will certainly experience accidental file deletion. files deleted on MacOSX and Windows will be imported to the recycle bin by default. In Linux, if you do not use the alias (alias) to modify the default rm function, rm... using grep to restore
Tips: Considerations before restoring a file
There is a problem with the media, if the system prompts for raw or other file system is not formatted, ask if you need to format. At this point, do not follow the prompts of the system to choose to perform the format operation. Otherwise, the data can only be destroyed two times.
1. Simple operation six steps to retrieve data
Data lost, the mood is urgent, to quickly find can try Photorescue Pro software.
Through "menu→setting" into t
The following tutorial will show you how to restore the rm-dropped file in the Ext3 file system. Assume that we have a file named lsquo=test.txtrsquo=%ls-iltest.txt 15-rw-rw-r ndash; 2rootroot20Apr1712: 08test.txt note: ldquo;-il rd
The following tutorial will show you how to restore the rm-dropped file in the Ext3 file system.
Suppose we have a file named 'test.txt'$ Ls-il test.txt
15-rw-r-2 root 20 Apr
Restore accidentally deleted files under CentOS6.x
When you realize that a file is accidentally deleted, do not write the file frequently. Otherwise, your data recovery volume will be small. What we need to do is to immediately stop all the services on the server and directly killall the process name or kill-9 pid. Then, mount the partition where the file is accidentally deleted and remount it to ro, read-o
In the ext2 File System on linux, debugfs is used to restore the deleted file-Linux Enterprise Application-Linux server application information. The following is a detailed description. If you accidentally use rm-rf xxx to delete a file or the entire directory, it can be restored on the ext2 file system. Because the file data is not actually deleted, but the index is deleted, the file creation, modification, and other file operations should be stopped
1, installed in the computer "Le Isia Data Recovery-Professional Edition", this can be downloaded Baidu search.
2, then open Le Yijia data recovery main function interface-"restore deleted Files" feature button.
3. Enter the partition selection interface and find the computer letter you want to restore, as shown below.
4, data
How to Use ghost to restore files using ghost
Fault description: the hard disk is 20 GB and divided into five zones. Recently, Partition Magic Pro 7.0 is used to merge the two partitions D and E, during the merge process, because the data on the e-disk is not backed up, the important files on the e-disk cannot be read and displayed on "My Computer.
Problem Analys
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.